{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Level 1","Scorecard-Level1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Level 1","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
["OBJECTIVE","TARGET","OWNER","REVIEW \nFREQUENCY","October \n2015","November\n2015","December\n2015","January\n2016","February\n2016","March\n2016","April\n2016","May\n2016","June\n2016","July\n2016","August\n2016","Sept\n2016","YTD \nFY2016"]
[null,null,null,null,"A","B","A","B","A","B","A","B","A","B","A","B"]
["GOAL #1"]
["Ridership Building","Increase Ridership to at least 24 passengers per revenue hour.","Ruthie Reyes Burchard","Monthly",25,22,22,23,23,22,23,24,24,null,null,null,23]
["GOAL #2"]
["Reduce Accidents and Incidents","Collisions per 100,000 Rev. Miles - </= .55 – The 2015 KPI result","Dara Chenevert","Monthly",0.55000000000000004,0.6,0.56000000000000005,0.56000000000000005,0.55000000000000004,0.57999999999999996,0.55000000000000004,0.55000000000000004,0.56000000000000005,null,null,null,0.56000000000000005]
["GOAL #3"]
["Be the Regional Lead","Secure 3 New Major Collaborations with 2 or more Partnerships each, per calendar year.","Lena Petit","Monthly",0.45,0.78,0.6,0.65,0.67,0.7,0.79,0.87,0.98,null,null,null,0.69]
["GOAL #4"]
["Stakeholder Awareness and Respect","50% of company resources for outreach activities will be utilized only when the activity strongly supports one or more of the 3 main strategies (1. Be an employer of choice, 2. Be a change agent, 3. Be the transportation agency of choice)","Marco Sandusky","Monthly",0.38,0.62,0.47,0.49,0.5,0.5,0.54,0.61,0.55000000000000004,null,null,null,49]
["GOAL #5"]
["Build and Deliver Innovative Services","Build and Deliver Innovative Services\n• Add at Least 1 New Innovative Enhancement to our Service Menu Per Annum\n• Increase Non-Traditional Revenue Streams by 10% Each Year\n• Add at Least 1 New Innovative Enhancement to Organizational Management Each Year","Jeff Seward","Monthly",1,3,2,2,2,2,2,2,3,null,null,null,2]

{"sheet":"Scorecard-Level1","index":1,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"GOAL #1","GOAL #2","GOAL #3","GOAL #4","GOAL #5","GOAL #6","GOAL #7","GOAL #8","GOAL #9","GOAL #10"]
["Objective","Employee Participation","# Activity Levels Completed","% Activity Levels Completed","Gap Closure","Development Ratio","# of Internal Applicants","# of Internal Applicants Promoted","Ratio of Internal Promotions","Time to fill Positions","High Potential Atrition Rates"]
["Target","Have a minimum of 10 participants in the development program/month","Have a minimum of 150 development hours completed/month","Miniumum of 20 total OJT Assignments completed for the year","Participants must complete a minimum of 75% of development activities per schedule on average for the year","Participants must close at least an average of 75% of identified gaps per schedule after development activities are performed","The ratio of OJT vs. external development must average at least 50% for upper level Executivies","A minimum average of 30% internal applications for leadership openings","A minimum of 50% of leadership positions are filled internally","An average maximim of 45 calendar days to fill leadership positions","15% attrition rates among high potential employees"]
["Owner","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name"]
[null,"< 5 Participants","< 100 Development Hours","< 10 Assignments completed","< 50% completed development activities","< 50% of identified gaps closed","< 33% OJT ratio","< 20% Internal Applications","< 33% Internal Promotions","> 60 days to fill leadership positions","> 20%"]
[null,"5-9 participants","100 - 149 Development Hours","10-19 Assignments Completed","50% - 74.9% completed development activities ","50% - 74.9% of identified gaps closed","33% - 49.9% OJT ratio","20% - 29.9% Internal Applications","33% - 49.9% Internal Promotions","46 - 60 days to fill leadership positions","16% - 20%"]
["Goal",">/= 10",">/= 150 Development Hours",">/= 20 Assignments",">/= 75% completed development activities",">/= 75% of identified gaps closed",">/= 50% OJT ratio",">/= 30% Internal Applications",">/= 50% Internal promotions","</= 45 days to fill leadership positions","</= 15% High Potential"]
["Oct. 2016",5,155,2,0.5,0.6,0.5,"N/A ",0.75,60,0]
["Nov. 2016",4,150,4,0.65,0.5,0.75,0.35,"N/A","N/A",0.2]
["Dec. 2016",7,165,3,0.8,0.45,0.49990000000000001,0.3,0.5,53,0.1]
["Jan. 2017",10,90,2,0.78,0.65,0.8,0.22,0.6,45,0.12]
["Feb. 2017",12,170,5,0.65,0.5,0.6,0.15,0.75,56,0.2]
["Mar. 2017",4,122,4,0.6,0.45,0.66,"N/A ",0.5,43,0]
["Apr. 2017",15,150,3,0.85,0.45,0.5,0.4,"N/A","N/A",0.14000000000000001]
["May 2017",8,169,1,0.7,0.7,0.5,0.25,0.5,55,0.13]
["Jun. 2017",9,136,5,0.4,0.45,1,0.25,0.5,48,0.1]
["Jul. 2017",12,175,2,0.9,0.5,0.49199999999999999,0.4,0.33,50,0.09]
["Aug. 2017",11,145,3,0.8,0.8,0.4,0.5,0.33,48,0.12]
["Sep. 2017",11,180,4,0.8,0.45,0.35,0.35,0.75,62,0.15]
["FY2016\nYEAR-TO-DATE",{"$f":"AVERAGEIF(B8:B19,\">0\")","v":9},{"$f":"AVERAGEIF(C8:C19,\">0\")","v":150.58333333333334},{"$f":"SUM(D8:D19)","v":38},{"$f":"AVERAGE(E8:E19)","v":0.70250000000000012},{"$f":"AVERAGEIF(F8:F19,\">0\")","v":0.54166666666666674},0.58765833333333339,0.317,0.55099999999999993,52,0.13500000000000001]
[null,"AVERAGE","AVERAGE","SUM","AVERAGE","AVERAGE","AVERAGE","AVERAGE","AVERAGE","AVERAGE","AVERAGE"]